SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194019 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194019 [ RunTime:0.001902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184798,11355,849123,456185,669411,364149,780112,337343,350553,823511,357546,996220,210059,889876,617197,1014168,299646,137117,558924,866566,656866,278808,464793,22605,815096,162818,420942,388975,182610,441939,594905,527687,987789,414533,565850,372246,244486,486197,519280,140453,1006690,220975,813568,953545,925592,969048,569272,333170,988377,178955,555787,105076,321212,1000180,583094,151475,320060,643205,679649,259699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001624s ]