SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487515 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487515 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642369,193742,470568,64273,71327,728620,901672,516441,459723,621471,573250,1013131,619811,1013426,923953,136774,164109,722468,500336,233954,331451,1011320,654805,864041,253744,447335,415347,1019759,29296,924723,94674,913281,777702,1020501,658308,439525,190018,677918,659460,191680,102571,264087,34283,844010,373491,621710,50895,179533,1000942,229333,975558,1006682,308153,1014955,677928,724574,98154,761106,539798,1039439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]