SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345631 LIMIT 1 [ RunTime:0.000591s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345631 [ RunTime:0.002280s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502157,197499,475137,190047,739176,606144,331855,259930,391738,398592,917353,573384,150391,212972,451064,268171,352434,532957,475643,545129,827876,819098,30616,1044645,518338,982508,667141,203578,403944,929431,1007400,625053,972579,889669,910393,837395,605355,20231,183527,262659,653979,918331,961131,999569,276907,582144,303553,649926,331441,481469,363783,976845,149704,867373,129801,66221,105378,571158,574849,400544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]