SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429496 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429496 [ RunTime:0.002497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890197,382636,59263,177206,94908,1023298,237002,397713,545296,382607,314843,921434,596983,884838,598149,98452,263917,275390,954279,967092,980197,530224,850491,324034,881995,176850,365035,997471,1445,691948,875401,694409,77547,919704,82184,335338,955962,912996,199371,750844,831593,356232,364208,912090,285197,102954,208277,549199,534617,303192,551317,235067,997661,641673,731076,34469,92224,779153,933580,405170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]