SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 914656 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 914656 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835059,105506,650784,1030665,586489,87622,419119,202765,465519,435211,436482,774697,550907,1014936,151805,866885,225259,395786,855916,724904,1005597,785248,582435,399550,1042854,28578,278423,775756,554097,1025553,759975,199715,919172,198812,570140,424113,328691,482982,254616,185989,787971,564823,1046697,406210,101627,372162,960830,241958,337697,278758,1010613,896003,237454,934013,43339,994508,813559,243738,644432,179674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 914656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 914656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]