SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98230 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98230 [ RunTime:0.003152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (756480,861205,624941,1012285,142966,210663,1014670,434913,638165,855388,34300,118141,956034,730887,868218,114872,180223,523930,287593,326099,168332,700490,415813,157517,376666,703653,975406,282802,164900,230292,743934,788378,201580,817915,594867,400525,817406,64851,382514,735662,58836,688183,429152,151524,512056,370298,857366,843246,200248,134384,605658,955476,1032278,224249,587704,1028470,447640,202734,337577,1014012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]