SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564447 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564447 [ RunTime:0.006484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513163,123520,159784,430901,618490,455989,24685,1005216,950948,788293,499691,938420,823891,204687,735437,497381,959099,56571,471606,242980,994585,302532,913149,210337,897395,839817,735717,786860,348413,669597,210000,429781,870755,340310,845933,583228,165630,930305,150778,680243,30244,121771,535583,223301,229966,828199,95554,54908,397627,814718,92810,228891,943962,137676,315487,650476,16170,1011170,331157,104627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]