SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015417 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015417 [ RunTime:0.002056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194818,370495,778192,606203,253880,587487,662810,544040,914664,98736,890980,203317,711174,443149,426637,768799,61144,123853,764835,65057,703370,681369,12373,539983,439845,719757,488004,99158,999220,305669,723075,376944,460976,148364,183816,715597,95501,106902,908608,481426,831497,580086,138275,557529,496943,350170,155937,602431,405679,51001,621725,475416,8687,153243,784809,154337,532496,295889,1001486,829668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]