SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487763 LIMIT 1 [ RunTime:0.006886s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487763 [ RunTime:0.002614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676798,105333,130561,567855,1045516,776688,648744,960115,11640,637444,587974,128187,880999,674266,735128,319361,890514,843970,103889,31765,363741,181877,543866,751233,776656,876677,988972,895761,439518,439997,37695,983338,357461,359706,580207,55485,837897,11110,868435,78534,703088,370518,70618,21277,557182,529783,899929,885295,518560,441295,449673,424975,120931,609214,149271,796171,781629,69016,152962,613667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]