SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040678 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040678 [ RunTime:0.002231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543772,696749,147079,66928,73618,296229,586338,294059,564876,988300,478506,721962,21738,632546,228357,856535,602971,136583,70255,910656,212136,966505,735272,506421,213502,25891,30733,918394,437151,48615,493213,636013,784231,534021,496455,76909,674513,253211,349826,74176,980387,244760,889066,491824,655938,351012,641574,146490,208256,357652,399882,879432,404412,410197,721912,198330,752940,578740,590200,218294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]