SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001864s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920643 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920643 [ RunTime:0.002426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007541,206838,867469,704171,1047551,174005,645679,920925,556965,354988,932740,531673,631508,780084,885707,759074,1048426,230017,264304,300662,287336,434985,657293,1028717,934438,791029,240219,616355,587052,612376,977389,346296,224218,491542,963125,778434,564442,407457,228074,880466,66625,156301,184593,396659,831967,511399,589203,294619,424516,902016,555868,127402,155301,798626,662302,736775,263028,293388,423621,452677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]