SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003626s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014038 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014038 [ RunTime:0.002838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277302,624231,907972,473504,307075,314309,672837,142614,153254,769834,535218,1030418,480753,535676,234034,1014868,143044,256303,21318,946427,204559,734332,118217,598252,462102,891489,998245,691497,295053,387,654656,742706,515861,385964,749995,269781,390027,580869,493008,853082,760018,164579,960577,281437,458940,188489,2739,780042,327487,427553,455541,275145,1006843,910577,318184,776427,851545,491574,923340,438910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]