SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417809 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417809 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959082,999159,746447,578075,851789,421702,500790,1037868,426165,1011491,476165,238272,370955,15808,728891,828463,1023436,412400,891381,506386,507374,613331,911193,763404,782649,971613,517105,207631,1018288,650887,862254,562257,14275,935707,471271,410765,254315,466759,554034,579655,64040,229349,167373,691808,456,200807,457421,173515,625765,473893,334399,332572,540644,612777,683831,448408,451632,569263,365923,870171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]