SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482489 LIMIT 1 [ RunTime:0.001026s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482489 [ RunTime:0.003712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191214,655843,307690,233916,107400,481997,225283,492136,567413,336721,22713,132801,764148,420914,652316,997820,436764,421007,704166,917993,866013,588630,469284,420946,330085,244187,787099,109849,752458,549968,637833,152789,758822,15081,333753,759820,616485,549102,52278,223352,9484,559915,877470,181398,782705,539291,892905,601045,564884,899899,719786,600210,98404,233663,66672,130970,489282,915225,37557,350588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]