SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044369 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044369 [ RunTime:0.002565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354796,152095,915283,890776,528931,131825,666559,982529,22528,443944,378026,200407,110328,836927,302342,457951,127274,725383,993208,184080,395155,84558,369676,394279,66726,598788,57044,329959,429313,553126,539168,949869,535331,497229,363845,1027395,506579,646002,84426,969567,345747,361937,764717,82530,530139,459963,45846,249717,703823,753212,580639,824973,501338,173827,162012,136500,454293,614135,806051,595826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044369 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044369 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]