SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014494 LIMIT 1 [ RunTime:0.000855s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014494 [ RunTime:0.003716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588961,39840,103776,337587,307861,29502,492591,1029390,657920,622102,887995,331076,172712,163342,872095,970080,611826,990503,844874,324644,594318,930008,51284,43668,961322,439713,203386,89981,624900,573662,95610,355516,62791,261318,705378,546,447496,432457,407470,664118,911501,916427,994130,197915,825513,313774,886899,722706,854176,981219,968882,788144,873458,376410,439306,354167,471043,505131,853535,367955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014494 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014494 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]