SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002925s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043535 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043535 [ RunTime:0.008195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283191,1038020,68076,518521,597341,719506,170762,512921,357968,1027514,301124,83287,550120,298765,542123,330678,152467,9483,352900,875478,168539,121256,444728,776979,776208,487087,176988,492496,30749,525238,953378,953058,78531,576807,217474,732245,980480,1040759,795689,200003,449473,582213,265582,906692,451205,512499,886611,728510,74069,350314,371379,235470,562307,891815,1038765,364031,469365,679597,412019,255524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001849s ]