SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109240 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109240 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423144,1047096,175232,143286,21155,1001926,130815,283178,586866,560497,745903,61951,400847,995297,97112,809360,420780,367950,142824,743088,436155,941368,539200,303111,670105,344720,365020,832142,502478,19491,49330,891147,7840,510166,835926,458925,666073,621782,619069,38014,103206,168309,728570,274215,596455,424747,455851,365041,1006566,518461,572018,15095,813422,478955,676890,752171,502383,753323,79134,336651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]