SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020353 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020353 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (934010,558007,426916,930389,472900,215929,926103,804698,90614,239358,153139,592850,503653,606376,588372,615677,1029864,959203,82301,991892,945128,620297,356928,533284,61278,707400,566884,578233,918511,32539,861258,408707,196651,405787,591305,123750,522477,727534,71285,1016809,284548,1011018,85442,672666,676469,986352,795860,398365,1036441,970552,589886,300311,372660,943445,204354,83304,390267,191605,291148,864266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020353 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020353 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]