SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042170 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042170 [ RunTime:0.002018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495071,365948,64905,225566,989766,877335,640125,775676,310653,541387,82109,487596,852952,930647,861878,43883,846265,1034162,229759,839478,597363,659921,937360,158549,187176,318850,880621,112943,112529,321548,560615,334624,810332,624844,516399,156627,73953,107648,374411,262149,464731,921736,367902,582737,765011,918384,597517,80085,36791,421564,764089,301875,738113,998036,700645,428013,614646,754074,482542,42760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]