SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485281 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485281 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691943,858053,828361,135435,87718,148411,261836,1041658,692446,580700,1045924,327478,418303,38089,480110,646994,302134,712903,557024,676886,656897,340661,589811,843268,312171,983233,410662,124864,277286,533480,93539,441584,97384,303872,488237,135364,932435,15076,292804,852153,765261,31579,976908,1016848,199390,519833,381834,813682,392517,640213,705039,113172,43574,1002552,842322,820122,232188,362615,69588,272778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]