SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971318 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971318 [ RunTime:0.002063s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741283,644530,217461,607595,930480,952124,201120,671477,680128,708953,811105,108714,163555,426255,526458,708977,200304,891526,393205,705410,760258,830056,431748,388895,939868,529645,586462,151602,977428,353303,731817,240274,477150,938269,857668,180524,672159,351154,526625,228633,525241,944956,727780,275144,560619,437251,193453,229542,580515,199710,981025,287727,938096,740276,1010649,757663,858526,503172,848886,551826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]