SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501979 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501979 [ RunTime:0.001978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42592,338118,735392,552176,572504,795061,716220,459731,1013351,406998,204769,665981,901208,735416,261196,484317,556578,896336,970404,550514,523455,83480,439962,773248,104595,1967,725822,367369,663427,683615,616327,1031016,932442,724819,572691,841652,501728,765813,1019462,516313,987856,790186,174977,56688,966489,1003338,934054,194164,997304,926982,710363,248381,595680,677348,424608,599639,807678,82018,999811,842227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501979 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501979 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]