SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421480 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421480 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026557,20577,986749,247217,743982,832814,992154,848107,343281,819233,500014,1010309,922878,871107,82393,312912,106142,496412,940770,253803,936555,306142,1026543,200407,324203,774090,633139,654904,828937,781102,495123,604619,406741,170811,884762,980240,741001,779532,74305,125170,490928,286662,664222,215780,557577,217365,601137,318330,247649,233298,461988,17273,731630,131139,1024306,492227,554187,777680,673325,208538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]