SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501567 LIMIT 1 [ RunTime:0.000657s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501567 [ RunTime:0.002631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203521,941954,741959,148241,433348,792846,567904,694064,883518,397056,114163,142688,713918,908896,173655,307121,487904,725314,585055,660709,62669,386104,747952,127641,365081,564940,454170,899324,169136,557510,153161,740263,174629,232437,141069,939689,777140,439172,772569,291805,387782,168982,397250,461488,777998,272169,678586,20653,168225,429886,674662,297495,984440,837459,743487,189360,694715,684091,412000,47829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501567 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501567 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]