SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145257 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145257 [ RunTime:0.002020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122214,638108,471671,845624,712180,644929,636910,743782,314194,432897,287219,455844,235992,17730,407000,821660,973602,828537,705678,432273,95832,265246,999691,552183,359997,63467,931493,218775,445397,615402,519320,588587,1044335,356160,246059,253851,536959,632475,509718,15831,981743,382945,777153,938238,658110,361510,402247,159301,247142,435557,830236,59066,385205,384009,739739,255280,181467,791741,190149,433238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145257 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000742s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145257 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]