SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001980s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016543 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016543 [ RunTime:0.002228s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357534,710866,68288,665794,1008075,397712,51311,79880,279976,78003,766107,750714,291917,954067,159310,162296,1041261,586165,334864,930383,610564,519439,994067,196694,627101,234008,864318,261973,132247,830372,521472,71468,710872,94395,819589,693361,474338,337095,22031,16236,495933,666835,600991,336259,878678,42083,408479,435921,126469,782298,295270,952407,587541,110072,277256,929268,789137,737181,466575,567081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002002s ]