SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404175 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404175 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293469,417019,952191,128129,576542,128265,833455,85215,580322,157635,404504,708196,191895,616150,520538,146038,901173,608902,303624,563567,712088,811124,627854,268979,625608,19699,78709,851253,908602,807809,916078,551803,725367,700994,544151,23647,597269,99627,660268,30300,29686,1013774,955966,428018,584080,959394,554525,813947,228615,254380,236872,719941,742378,603168,1018037,693898,543090,328563,859224,584730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]