SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503405 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503405 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569525,267359,248865,807217,997470,970427,479797,316418,654163,507639,970011,228504,454355,349285,151921,170788,783529,786731,261522,239840,989353,594295,78905,1036967,259430,131816,192422,34887,197449,118854,657885,419855,429480,124574,42668,959504,1007297,234096,354098,498715,581146,25590,531535,294337,88399,604071,920045,377920,914538,753799,294948,35498,708960,1012077,774831,823114,568173,973945,726040,969571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]