SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002359 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002359 [ RunTime:0.002111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475659,985837,308428,631607,422529,313064,102796,146245,271732,555657,561732,621425,306298,889969,959347,108883,121509,186035,214047,595970,694426,1046212,76907,1006733,866920,824554,293585,728147,74562,651833,978103,997419,881678,916582,363475,663092,793744,27660,540629,232860,298187,620697,722428,463723,748021,75710,245074,431811,891317,804948,684478,1010185,374391,924711,159688,913955,291310,292083,14460,763305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002359 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002359 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]