SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002000s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588024 LIMIT 1 [ RunTime:0.001010s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588024 [ RunTime:0.002742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426532,89501,154698,195608,475588,821820,776175,140239,545007,346468,665782,275359,389285,979177,952936,157139,185339,814920,668741,171346,1004875,588983,223736,233025,831430,931146,432114,515854,650950,792663,102046,367168,294754,286176,644020,925893,1039671,951661,217534,275482,265089,577198,145000,743980,230913,723030,744805,700708,385955,711592,441498,668631,256785,1027206,620005,580005,424049,180147,94533,70458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.038440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000644s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002254s ]