SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444231 LIMIT 1 [ RunTime:0.000923s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444231 [ RunTime:0.002359s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509150,881307,601098,191564,47527,1013167,192199,100663,585092,179872,581896,461249,111552,445790,356804,192351,494413,261843,631926,714731,971777,631880,378243,435715,842549,1021404,530432,1026962,856890,770390,187165,135228,466500,213284,810772,249537,108152,175623,42312,401301,193714,206037,166450,257770,638813,739852,751079,379952,813170,814889,622872,103061,507328,527650,306806,5367,611482,395987,981710,355138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000887s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001177s ]