SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 948171 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 948171 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820131,631179,194496,1035848,221650,762973,1008686,830331,1012986,104013,579611,161191,969423,500487,369605,340675,385760,273531,507616,801918,383182,508846,95432,623800,230349,9695,531116,368478,452444,343754,581271,39104,678684,621766,47220,65608,775027,41011,405280,583417,481645,13517,747505,522168,971815,77383,925322,94097,69262,357965,355551,397511,797790,891122,701391,29644,738680,831614,100143,860284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 948171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 948171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]