SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44103 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44103 [ RunTime:0.001432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350561,527318,501294,596379,84002,637729,1038710,412709,368473,880251,823306,1001622,821000,226893,36051,995256,26998,493948,24549,135405,47686,626083,479508,608039,794272,815802,650926,687317,95568,681337,425873,1012771,923766,258705,994998,874097,261921,424040,229328,589254,205044,932026,226969,514691,146928,872959,180778,96698,919435,276285,40687,616044,216996,725580,218604,1002439,490650,863148,1002623,1009991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]