SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34136 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34136 [ RunTime:0.002590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874440,145126,259273,644694,695284,282958,413097,241708,377102,49399,94888,362088,471554,214853,609782,750296,442861,592315,897606,371469,724308,199546,603589,769396,602558,23392,606155,70379,237809,786734,229256,660374,304172,1024979,34409,224081,1026318,696526,245396,186907,1006513,375248,101707,522303,916135,701113,509985,299589,847234,558469,830506,144007,46988,175660,718801,781726,9997,585456,835903,550838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34136 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34136 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]