SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51552 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51552 [ RunTime:0.002290s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982673,457962,843618,160489,303155,52641,522239,382890,195964,734329,510346,142859,513717,710111,971036,119176,50499,1011842,865601,653823,330823,459548,511731,959864,751712,110685,114261,213389,865429,320679,942535,528221,31754,872374,185682,12215,767899,300852,1002727,184,570063,226552,112674,912497,246786,656717,664062,415384,856136,663724,736528,662117,383445,787508,378768,678967,41258,793293,94889,349548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]