SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005140 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005140 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (769841,605091,595062,390348,224948,648613,645234,354289,81093,550454,232752,50468,533158,576184,991493,282596,312037,1007124,118081,312057,415285,1034638,139117,252043,336238,139297,991711,301708,892519,975418,777022,717536,841428,918067,623608,378864,948576,409691,85013,942270,746635,643094,961680,241242,770438,278444,903626,840018,330416,231240,744627,589915,976496,750399,202546,261620,728444,934008,354087,265012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]