SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016418 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016418 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295793,625197,782540,141651,560430,984123,925231,893915,320354,993175,525059,1003980,698696,662641,395599,994493,114360,243690,261486,667394,261383,619791,404715,651282,51069,672887,587897,855793,548349,270454,457561,746625,989737,1037800,520796,335129,490323,699740,973579,5986,985615,70177,697614,719777,770887,995070,230198,928512,446634,797206,446904,272134,381418,953039,195940,514377,568968,602617,516791,497680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]