SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427104 LIMIT 1 [ RunTime:0.002062s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427104 [ RunTime:0.004458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83762,364137,231298,680725,110739,785654,176689,500364,848161,786988,576487,523159,510400,149267,829769,24290,90196,387485,819090,881156,994627,693942,421046,169845,361491,625859,945658,702240,530023,1013070,641402,401875,503256,710464,736709,17795,172540,345769,586201,896751,13532,957921,834161,906114,217049,447268,817683,755109,965204,193739,719779,386793,779256,458768,591914,1017420,667044,148261,527961,266037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001195s ]