SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310429 LIMIT 1 [ RunTime:0.000520s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310429 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643891,757623,334024,285644,816535,817010,85259,374878,927313,289047,413068,2665,816191,999650,588252,640019,36978,1020102,603616,534654,49991,544067,247276,723197,167944,163156,401045,487249,119692,468971,963154,532496,371470,526146,9920,800886,642041,410194,342253,365462,1018536,945456,642978,808320,953573,69313,465615,672522,687485,248303,962377,423673,677213,717559,985770,1005239,245697,744112,866028,111066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]