SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037406 LIMIT 1 [ RunTime:0.000614s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037406 [ RunTime:0.002349s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961355,677813,575054,266448,882999,693783,26207,396958,734680,1017625,669321,600007,800385,382862,42617,370369,33666,370245,271041,998780,618654,270400,712758,707223,528121,407903,535904,44940,833574,59693,598705,390414,374724,283349,874720,538824,972773,246409,242749,474326,965225,145375,496063,672764,119128,686210,868363,195839,735913,243184,520882,111650,623035,623347,904572,457414,724388,302941,996049,144072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]