SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841081 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841081 [ RunTime:0.002571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (784107,20135,148999,936156,1047465,230089,513767,922346,973785,754397,416723,674775,382800,829359,866523,122870,497163,915242,952455,789733,934258,1044017,929422,990679,374165,106200,151948,275118,500562,922820,204209,374455,348512,1011453,55737,863278,539582,969798,446330,905645,856972,543937,696240,115659,355754,537476,602673,923920,403796,683688,834749,951224,377543,544856,175147,700174,648030,352858,143257,788982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]