SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469028 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469028 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (659006,91015,780488,315960,564241,116111,664935,949267,892059,523628,845943,305718,998122,278432,11688,852170,629414,744850,659415,127965,991246,492004,100798,604645,755233,546422,621788,185276,621341,724600,217762,579174,174082,305873,817204,160350,48812,628694,188727,962088,143069,868661,190858,197987,843133,60514,853636,942996,441676,669442,776879,528144,989048,82336,118764,691669,691355,919284,769472,685011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000777s ]