SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001662s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420078 LIMIT 1 [ RunTime:0.001658s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420078 [ RunTime:0.005329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321877,489850,659259,605873,1011091,142829,442685,855449,887538,401730,948983,235406,613576,743000,846708,36760,182516,827695,613113,171126,912020,149372,1016284,301123,699640,848922,780644,126263,712642,806798,807288,216862,65005,979901,146394,894252,155208,235048,969975,232250,950539,453049,716229,91247,775637,381177,831272,729786,825094,877294,464265,977884,410405,418286,190467,235892,616893,344715,407599,755456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]