SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001537s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502630 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502630 [ RunTime:0.005795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517741,672103,47540,145285,977694,828566,523288,179257,452481,780228,751647,257742,975391,1002206,437864,820040,461582,48172,121268,353913,915857,644235,371828,283370,80942,773365,223997,255157,527366,52906,144222,644694,1043448,175730,812954,591821,408573,76265,355949,571282,857799,821546,80069,949916,471697,90998,556957,576361,324188,688510,296435,1011982,581933,677516,968842,16962,334144,785435,838017,612781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002727s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]