SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203651 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203651 [ RunTime:0.002311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (823016,421865,480035,995635,829443,141471,946115,584401,936089,519354,835574,464316,96441,742093,571899,650356,1042608,1040876,989295,383726,861007,462237,449400,523044,503086,915781,823853,380576,729765,878531,43888,741877,434128,74930,15378,748691,356298,150157,228041,353249,6792,489042,246321,364833,361367,13082,53334,173079,943157,811783,61403,985379,47973,361840,345781,466057,530576,282399,936315,340763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000836s ]