SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 972601 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 972601 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516954,683311,877600,371359,285555,40446,99625,933107,44011,902745,430992,529396,171202,146175,620802,427425,1041369,248086,203424,375397,693941,14657,26320,832758,730375,738646,524663,347461,737177,140737,640006,44679,756901,670851,149311,286226,721407,221024,588842,862195,622252,678496,718015,147707,987471,291446,638558,12526,923125,480976,695190,861412,305272,203460,19289,236030,169506,812278,537868,888693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 972601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 972601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]