SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475176 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475176 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256232,996024,536872,960981,355685,1037096,331093,216543,354805,430884,132012,876585,217633,679207,49374,817300,695398,493919,644435,784418,624549,12755,140537,396487,994227,793365,516856,783535,515022,403512,704301,712399,1022751,896038,779249,608975,539324,824475,153174,133081,529530,470959,296379,659464,836688,651996,694175,112012,702262,1006616,874994,79958,662769,406068,244823,740849,142204,583159,579163,788861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]