SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014108 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014108 [ RunTime:0.003437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310272,235049,1037839,246522,264037,297099,838040,774903,924730,6545,70805,261744,828111,269184,488342,650491,794186,459612,57941,449022,329704,533363,629916,904648,120045,626392,253285,769786,1685,574179,833114,905648,160226,105212,420501,314381,376597,617782,878432,586660,955154,971892,624568,414989,664835,90128,588105,857202,329057,121488,597595,159013,664951,267030,854379,364223,270709,578337,475566,788584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]