SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489509 LIMIT 1 [ RunTime:0.001389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489509 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328902,972861,21792,388184,184630,410734,889696,818724,527219,694637,465187,1015914,382915,1015634,1006535,573583,1021078,167796,329478,1001535,1047964,388219,74849,587555,39090,735911,716848,440245,574716,930850,100223,282779,228287,521416,1042160,804934,372046,101797,49643,1033033,225508,733920,180243,817283,700153,17917,908500,878680,1023280,138275,540460,1011463,429407,761732,70060,720546,710853,938057,15938,841928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]