SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010867 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010867 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576879,126228,915536,488074,217430,502779,534906,604489,132195,772918,440773,949744,361003,958252,578463,390879,23288,863868,104381,903507,589848,1025994,763240,201513,310702,776941,356373,984904,354675,1012805,159449,901353,871295,626090,970966,618780,629264,685403,332522,335259,605033,620415,155946,59165,117710,178071,353547,370897,506423,12713,287794,876353,786254,366208,847795,385843,996385,848198,645271,633862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010867 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010867 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]