SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 891968 LIMIT 1 [ RunTime:0.000723s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 891968 [ RunTime:0.003686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023991,210549,556137,90092,779849,1032040,985755,718102,887222,26116,377840,340420,920083,35199,608213,989270,480792,58132,27661,473566,24726,183892,427364,112493,361294,1001204,251301,215983,2122,67000,760842,706882,788264,999575,135876,39851,721468,408781,514701,464566,345633,420369,187007,1044116,135921,178058,868124,315591,561798,966367,615969,1027107,720236,342208,890901,950485,210844,577523,923756,845606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 891968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 891968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]