SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51983 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51983 [ RunTime:0.001425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658984,30245,60845,1016994,587884,556231,755644,125143,646889,764669,487840,1007293,967003,482203,936340,583610,143111,132290,867803,497847,27135,389251,746541,573198,7383,690576,923538,878300,135756,521337,335007,209201,66326,635585,358080,718702,688476,770185,316993,124213,526896,364311,957199,410743,676704,899467,53749,606025,432560,803805,420848,419246,258750,279730,964657,992857,647965,302015,296025,734213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]