SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001720s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459752 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459752 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299345,417112,354653,847835,263657,622297,146792,239497,653727,94288,807722,263846,62346,70477,57278,838962,196980,985736,3336,417688,377364,82482,509261,628264,207028,1001685,337411,513927,1042482,309531,614898,225700,643175,690271,594800,626233,1018230,667383,14908,1026674,953211,99467,8850,1019565,360576,406857,535116,68660,593495,223834,715873,677920,355583,323406,936170,7356,282660,1508,799644,1033956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459752 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459752 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]