SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154961 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154961 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437289,853086,514383,593083,495188,640180,278551,380019,879340,416967,334740,379522,785316,494321,242683,175173,641480,1014874,348578,368073,550925,291042,308975,380217,95997,143961,54440,735908,144033,422791,357720,371530,229601,470391,833385,1019372,704562,1001756,296282,274076,224816,536409,295214,974784,29343,418651,51470,834273,642936,226143,1045296,514597,799297,721381,1025366,329471,602070,385763,149467,68639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]