SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52096 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52096 [ RunTime:0.004134s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485707,417053,805717,183480,93725,958519,575258,274728,990619,167838,19725,829051,698560,262290,825778,1018382,871353,321618,656177,748123,670625,696031,257730,553503,198159,598210,272800,392384,597025,990494,436089,2702,90984,327203,836976,198755,407144,712174,1043582,27046,397668,598411,944955,670641,255084,222066,670496,1008069,360673,509101,978518,224667,754974,201438,773811,533932,767510,846536,409185,941539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]