SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416980 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416980 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29505,125748,1030283,81292,719563,336020,168450,132215,474704,515554,881286,334653,253319,730990,360125,154672,803898,729039,46992,330692,356370,287211,755072,53347,142065,49968,1021092,232631,917090,589331,1000136,260989,363760,720366,20207,1009948,682390,177967,413525,805372,422730,392460,283163,883684,38647,664417,98663,870680,1030169,566719,828777,798746,366991,275597,483215,954805,92464,667082,450845,136286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]