SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447018 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447018 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938708,488112,379470,943174,773205,554870,150714,428277,197300,420235,543715,803141,517125,554516,560531,877539,523463,517270,524132,147260,136639,79105,698960,680716,79932,966890,132850,778051,1038021,486403,419093,939687,1029063,413757,475235,208548,825076,256927,849886,398282,347886,731247,227887,738803,544595,377984,806421,666751,330312,353977,660679,518197,398997,928052,155423,312406,341754,584992,372805,725258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]