SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555417 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555417 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211043,195436,199199,1002724,902421,945103,510713,359606,65248,356760,538574,180433,212114,479161,162278,442275,923653,334838,541991,20637,850121,488722,756596,621196,936943,123240,889901,895472,281704,643727,614959,520427,119000,53535,230154,314831,845782,228428,6761,465822,597939,153442,956511,173274,64006,88497,780458,517266,608390,971550,282491,846038,494446,174965,579187,189731,660672,139236,579877,764981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]