SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002639s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398448 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398448 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855253,517316,137973,415735,925760,426860,606163,609880,1016221,701254,375201,313638,139900,7752,877386,798893,1013304,187977,177632,910087,710655,900010,301265,85238,209783,839413,667670,30227,949001,973144,225935,605028,134888,19307,300485,447861,36212,829417,426849,513491,494503,995355,730076,812007,708470,1003079,57037,507340,280038,1003594,573136,789147,875272,105385,902687,1001618,315324,140196,206802,983764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]