SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012161 LIMIT 1 [ RunTime:0.004296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012161 [ RunTime:0.003059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671219,67384,583454,354473,966180,707540,610593,943441,997175,399855,186228,985162,997084,323035,35086,566479,656661,708897,149886,95497,41473,34605,628291,137638,970585,8275,484324,269047,53687,982774,996223,350817,87270,223468,1040167,834414,256278,464995,462219,491967,881359,815120,19167,289775,567490,138085,833876,996559,959656,468401,312463,751252,930715,198329,669406,30839,847468,607680,994921,295500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]