SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505341 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505341 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826756,607104,600078,856841,651081,142231,11851,943398,634297,992885,534263,408998,560499,585887,43105,839074,8672,694917,968026,199332,444800,410402,137704,880304,493531,364794,682597,740429,564832,690183,417874,279938,251839,368819,5913,714552,393846,666743,292634,526429,1000206,617589,577064,583607,173912,287556,4878,197986,458535,880008,400650,691208,544572,495169,177466,1026845,558834,455892,214925,61601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006696s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002907s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]