SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447918 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447918 [ RunTime:0.001933s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89471,424098,225801,510992,877728,567321,4410,314852,857409,855962,538196,104898,40421,536706,325834,596255,219220,413216,304752,182739,472644,1018146,792689,911450,707765,43816,957638,432681,591664,1013612,763884,374716,663665,449639,713103,766845,181927,920086,711308,919203,659341,582857,251443,425429,917786,43410,12989,433445,790664,929149,25506,991840,500212,505769,810130,292195,860299,233,606019,633642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]