SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 571540 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 571540 [ RunTime:0.002400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648438,543334,773724,583834,142593,193338,1195,387240,127481,373851,910449,356925,465488,568956,1026156,395703,482730,694008,975688,357192,210852,930514,730618,993733,227478,320498,838826,741867,13234,984783,276630,836864,405932,1025691,791288,165922,81959,498205,849725,695259,1024663,473800,869367,837844,240941,1019989,149719,562234,978895,205992,1022560,927913,452594,971627,425658,401461,154443,385279,467459,559731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 571540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 571540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]