SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511671 LIMIT 1 [ RunTime:0.003102s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511671 [ RunTime:0.003508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860635,393846,392456,814033,549914,57293,652838,280718,850990,793182,1038783,218765,686513,607778,901409,822290,1006854,863531,409926,339995,459691,934772,773049,233805,197417,953156,200848,877829,938781,833994,830915,596578,67651,715376,10529,7332,1019158,865363,860209,909917,284887,866968,459281,100582,553644,937291,505537,287498,306365,997862,683786,135671,265591,772065,536779,174850,12979,314958,1016641,1020872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000944s ]