SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519968 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519968 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559846,716564,979880,611468,822285,249247,268554,813449,115807,1031663,478752,1007320,461879,126878,271570,169302,572026,834783,751449,852584,324267,242669,885784,469471,126717,992615,182804,368383,592361,749999,393780,116201,1037247,637203,889829,3976,1012630,46936,384356,605295,863224,154136,709642,980207,48857,459577,874535,130679,700937,984844,562410,773728,829331,704393,946829,846960,171301,868469,150349,545451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]