SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391213 LIMIT 1 [ RunTime:0.000927s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391213 [ RunTime:0.003221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663575,120480,803994,363753,657718,640089,679471,633972,211130,159217,328304,485082,900208,583148,604021,276801,735784,8236,45579,710511,931329,290327,762632,834572,293133,399579,321923,68041,392829,40599,63266,269007,745097,417764,538548,546331,497159,903291,955317,194982,551028,81540,244716,354905,166606,120634,637614,1037457,559013,593166,629971,257938,621655,895754,96221,820467,671977,112861,997780,889630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002978s ]