SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001579s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 170412 LIMIT 1 [ RunTime:0.000535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 170412 [ RunTime:0.003796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587266,458370,334684,154645,633037,1006110,673620,531839,874017,429566,694684,284213,533800,110434,827207,998539,877978,323073,153980,1002702,130792,206004,607362,91594,283827,549634,42048,512053,968511,718204,764274,66438,345983,296898,422847,867733,663401,1015176,1039138,537178,234513,617490,1009227,771000,394970,746608,935448,380110,888760,955322,698907,823011,206879,985072,180318,421819,423933,833695,1010249,902988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 170412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 170412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002433s ]