SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305209 LIMIT 1 [ RunTime:0.001256s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305209 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236913,218575,922731,667267,626722,694931,402950,11184,431607,317145,788031,10302,78423,741732,853385,973223,270417,511069,297424,704918,131207,823624,454322,1021508,69802,759693,470188,579282,213361,325479,896692,857857,379684,175363,276138,466990,894407,659210,896964,277166,521863,647622,702816,554173,1015171,275314,398787,1038370,773049,1001668,631497,340089,1043736,789586,571449,1029741,666258,310983,215502,430622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002132s ]