SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479909 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479909 [ RunTime:0.002395s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151696,571652,641829,22234,409961,1017907,182038,363077,169286,159908,663495,946029,434230,404145,735188,470068,743541,102630,810884,982852,621938,43400,987058,804075,611745,195233,41325,598885,74721,684084,1030786,482969,404786,976188,87478,411843,907290,690626,954642,340536,56575,274616,5881,478598,789112,479215,301869,716118,1039985,985683,732186,968287,302441,721561,134622,356008,203459,936870,818103,532603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]