SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801183 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801183 [ RunTime:0.002872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (657576,78235,342410,19937,662142,880325,91032,880085,347101,712830,398223,653832,736273,227305,579097,559255,328111,1032880,644951,821491,754505,1048270,836827,681412,537740,102765,188688,686224,641771,841152,230127,838870,176629,267870,688108,183789,846122,440800,958367,214453,951714,494373,775251,370831,522987,692952,182763,869144,207575,1008860,927169,363108,1042297,752773,805639,197265,491779,302195,809309,308388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]