SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198540 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198540 [ RunTime:0.003038s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421725,987677,852802,943495,622109,972690,292711,839600,186457,432668,2936,607324,946130,508823,948926,246244,1013491,10480,135823,841904,895769,393808,787337,1015846,206813,170317,511870,770106,2865,460174,534412,27929,533549,218140,712273,136016,289355,378599,1048181,336048,915661,717477,633870,255204,479106,439698,357740,619706,812693,908072,301076,182933,889968,216708,1012668,682743,125152,259575,547684,524050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]