SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001603s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576764 LIMIT 1 [ RunTime:0.000661s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576764 [ RunTime:0.003287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331453,129656,165078,919639,300828,645355,1023399,789525,58540,628175,868684,675752,23838,761608,123555,28448,1015413,514765,579434,782949,636170,419437,397597,581487,101373,50288,196822,920280,103574,352377,820800,790019,1002541,862691,166760,401222,417675,114358,196209,264959,1023171,435971,1029090,45329,897944,157942,863277,468036,422553,406126,506162,843357,386515,377675,807981,137829,572505,1033123,464543,1003526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001784s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576764 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576764 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003990s ]