SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003568 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003568 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445724,753347,721236,400756,1004741,337665,305670,830301,54309,7175,270469,4527,848044,165390,738300,992832,76447,396090,8446,995896,1010971,983459,717081,219065,216600,126664,970500,24666,449796,343360,933013,335552,929160,86018,683069,916051,520547,372177,914338,568104,415451,795415,998565,66980,806475,3406,489536,491871,22390,201027,210381,984850,391862,123075,445216,192539,51012,238381,317373,1011595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]