SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100673 LIMIT 1 [ RunTime:0.000870s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100673 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654812,1030631,993213,867276,634264,947848,291649,480921,95311,608068,463334,1031407,799852,840419,850854,627554,999401,465826,82898,638289,537708,602110,3285,724458,53480,49578,733525,311413,165335,435989,943681,374395,724875,395070,497704,771810,240970,46149,142000,618384,922734,209957,1584,19394,997435,428561,988297,954341,402174,913855,330269,633854,837648,941889,470719,1044625,456965,110900,875548,585694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100673 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100673 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]