SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505532 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505532 [ RunTime:0.001466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313242,807410,581570,181308,918501,96867,1020333,215297,640914,316234,996039,227084,634528,815137,534748,160293,401210,318479,384132,281030,793379,245625,918270,249314,585301,604286,315655,369759,426289,1016870,579550,1039671,989425,299911,917163,179059,226736,532572,98605,941232,727343,34969,595741,423259,829464,720312,314485,837253,717879,407373,49022,275522,409089,52081,989172,993067,288532,277842,300714,68790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505532 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505532 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]